Method and apparatus for accounting and contracting for clinical trial studies

ABSTRACT

A clinical trial study is modeled for automatically generating business intelligence information regarding the clinical trial study. The clinical trial study has a total budget amount and a total amount of deliverables. A software application program is provided that has equations and business rules that together define a process, a timeline, and deliverables associated with the clinical trial study. The program is populated with items including entities that have been contracted to provide the deliverables to the clinical trial study, budget items and amounts related to the deliverables for the respective entities that have been contracted to provide the deliverables, and for at least some of the budget items, a time frame in which the budget item is expected to be incurred or paid. Business intelligence information is then automatically generated using the equations and business rules in the program, and the items entered into the program. The business intelligence information includes appropriate invoice payments for the deliverables for the respective entities that have been contracted to provide the deliverables at a specific time frame, an accounting for the clinical trial study, and cash flow needs for the clinical trial study.

CROSS-REFERENCE TO RELATED APPLICATIONS

This application is a continuation of U.S. application Ser. No. 12/165,982 filed Jul. 1, 2008, the entire disclosure of which is incorporated herein by reference.

BACKGROUND OF THE INVENTION

In the life sciences industry, there are pharmaceutical, specialty pharmaceutical, biotechnology, medical device, biopharmaceutical companies and others that are required to perform clinical trials. Clinical trial data and information is submitted to the U.S. Food and Drug Administration and/or a foreign counterpart to gain approval for a new product. This type of product development is complex and expensive because many different suppliers across the globe may be needed to perform even a single trial. The process for managing payments to suppliers for the products and services that are contracted is also complex. Some reasons for the complexity are that the process often requires the life sciences company, known as the “sponsor” of the trial, to use many different suppliers and perhaps their own resources, in combination, and because the supplier billing staff does not know what work has been done by others elsewhere in their company, in other parts of the U.S. or across the globe. There are two major processes that are performed in order to invoice and then pay appropriate invoices for work/deliverables completed. (“Deliverables” refer to the goods and services that need to be provided to perform a clinical trial study. The deliverables include goods and services provided at patient sites, as well as sites remote from the patient sites, such as lab and diagnostic sites, or sites where investigators perform services.

On the supplier side, there are many issues in connecting the number of billable hours with the activity related to the deliverable that was accomplished. This makes it difficult for a supplier to provide the exact number of deliverables that were completed. Sometimes a supplier cannot distinguish between their own charges that can be invoiced for work completed and the charges of the supplier's subcontractors, known as pass-throughs. This might happen because the supplier does not wish to identify these items and their prices on an invoice. This process is the source of numerous, expensive errors. Bills and invoices that suppliers create often contain duplicate charges, missed charges, and other mistakes that the supplier and their subcontractors may not realize. However, the sponsor of the trial needs to know all details in order to understand several important cash flow matters. For example, a sponsor cannot continue to receive invoices for two years after the trial has been concluded, because it is near impossible to verify these late invoices and deem them as appropriate, long after the project has been performed and completed.

Currently, each supplier is only concerned with their own individual costs and their associated invoices sent to a sponsor. However, the sponsors need to know, for any time period, which remaining invoices will be coming to them or where the current spend is, in comparison to the total budget. They also need to know if the projections for cash requirement have increased or decreased.

On the sponsor side of the process, the sponsor must account for all the money that is spent by all of the suppliers, their subcontractors, and anyone else who is spending money on the clinical trial. The sponsor is responsible to take receipt of, track and manage, and pay appropriate invoices from the right suppliers, for work done in the clinical trial. This process is the source of numerous, expensive errors. Bills and invoices from suppliers may represent duplicates, erroneous charges, and other mistakes that neither the supplier, nor the sponsor may discover. These errors make clinical trials costly and result in higher costs for patients and their families, many of whom cannot afford new medical products.

As a result of the inability to accurately manage invoice payments, pharmaceutical companies often make millions of dollars of erroneous payments each year. Furthermore, without appropriate payments for products and services, valuable vendors might not receive payment for products and services and may no longer be in business to serve the clinical research needs of the life sciences industry. Without appropriate payments, the cost of drug development will continue to rise, making it difficult for people to afford important medications. In addition, the proper accounting of money that is spent on a particular project will provide warning signals that a clinical trial no longer is compliant with the plan for the trial.

Although the biotechnology company and the suppliers may carefully document the activities and the costs associated with the activities, it is difficult and time consuming to decide if an invoice is appropriate for payment. In truth, payment should not be made until it is verified that related deliverables are appropriate for the trial. It is not easy for financial staff to determine appropriateness, because of their lack of clinical knowledge and expertise. Likewise, it is not easy for clinical staff to determine appropriateness because of their lack of financial information about the costs and timing associated with the many different contracts. Since there are multiple suppliers that will deliver services for a clinical trial, and all have different contracts, confusion and payment errors can quickly become expensive if there is no integrated process and/or the integration of appropriate information.

In order to try to reduce the confusion and errors, some biotechnology companies have implemented clinical trial management systems. However, the clinical trial management systems have not been successful in reducing erroneous payments because these systems lack an integrated combination of business rules, formulas and timing knowledge to flag potentially erroneous payments. These clinical trial management systems also lack the near real-time visibility regarding the work and deliverables that have actually been completed. These systems contain only what has been data-entered into the system, making it still necessary to find the data. In addition, these clinical trial management systems do not tie into the objectives of the sponsor to track that the monies spent and activities done actually resulted in the right deliverables.

BRIEF SUMMARY OF THE INVENTION

A clinical trial study is modeled for automatically generating business intelligence information regarding the clinical trial study. The clinical trial study has a total budget amount and a total amount of deliverables. A software application program is provided that has equations and business rules that together define a process, a timeline, and deliverables associated with the clinical trial study. The program is populated with items including entities that have been contracted to provide the deliverables to the clinical trial study, budget items and amounts related to the deliverables for the respective entities that have been contracted to provide the deliverables, and for at least some of the budget items, a time frame in which the budget item is expected to be incurred or paid. Business intelligence information is then automatically generated using the equations and business rules in the program, and the items entered into the program. The business intelligence information includes appropriate invoice payments for the deliverables for the respective entities that have been contracted to provide the deliverables at a specific time frame, an accounting for the clinical trial study, and cash flow needs for the clinical trial study.

BRIEF DESCRIPTION OF THE DRAWINGS

The foregoing summary, as well as the following detailed description of preferred embodiments of the invention, will be better understood when read in conjunction with the appended drawings. For the purpose of illustrating the invention, there is shown in the drawings embodiments which are presently preferred. It should be understood, however, that the invention is not limited to the precise arrangements and instrumentalities shown.

In the drawings:

FIGS. 1A-1F show a blank Contracted-Budget Summary in accordance with one preferred embodiment of the present invention.

FIGS. 2A-2F shows budget summary formulas in accordance with one preferred embodiment of the present invention.

FIGS. 3A-3F show an actual budget summary for an actual clinical trial project, in accordance with one preferred embodiment of the present invention.

FIGS. 3G-3J show the detail of the individual specifications and assumptions in accordance with one preferred embodiment of the present invention.

FIG. 3K is the payment schedule in accordance with one preferred embodiment of the present invention.

FIG. 3L show CRO assumptions in accordance with one preferred embodiment of the present invention.

FIGS. 3M-3P shows CRO fee and payment schedules in accordance with one preferred embodiment of the present invention.

FIG. 3Q shows lab specifications in accordance with one preferred embodiment of the present invention.

FIG. 3R shows investigator fees in accordance with one preferred embodiment of the present invention.

FIG. 3S shows change orders in accordance with one preferred embodiment of the present invention.

FIGS. 3T-3V show tracking of budget changes in accordance with one preferred embodiment of the present invention.

FIGS. 4A-4H show where each budget item, cost, and the specific rules are entered into a spreadsheet so that it can be seen in a Project Budget Summary.

FIGS. 5A-5D show visit schedules in accordance with one preferred embodiment of the present invention.

FIGS. 6A-6G show patient information in accordance with one preferred embodiment of the present invention.

FIGS. 7A-7E show invoice-related documents in accordance with one preferred embodiment of the present invention.

FIGS. 8A-8P show where each invoice item is entered into the Project Budget and also show how each invoice item is processed in accordance with one preferred embodiment of the present invention.

FIGS. 9A-9N show an accounting of a clinical trial study in accordance with one preferred embodiment of the present invention.

FIGS. 10A-10F show how the values in “work-in-process reports” are calculated using the equations and formulas and the business rules of a “work-in-process report” for specific time frames, in accordance with one preferred embodiment of the present invention.

FIG. 11 is a flow diagram that depicts how patient status data and patient diagnostic data is automatically inputted from the entities that have been contracted to provide the deliverables to the clinical trial study, in accordance with one preferred embodiment of the present invention.

FIGS. 12A-12B show a portion of the portal database that contains patient status data and patient diagnostic data that are automatically checked as part of the business rules, in accordance with one preferred embodiment of the present invention.

FIGS. 13-17 show schematic block diagrams of apparatus for implementing preferred embodiments of the present invention.

FIGS. 18A-18AN show all of the formulas and business rules in accordance with one preferred embodiment of the present invention.

DETAILED DESCRIPTION OF THE INVENTION

For the purposes of explaining the present invention, specific embodiments will be described. These embodiments are exemplary only, and are not intended to limit the scope of the invention.

I. Overview

Preferred embodiments of the present invention overcome the drawbacks of the prior art through a computer-implemented method of calculating appropriate invoice payments to vendors/suppliers who are providing products and services associated with a clinical trial study. In one embodiment, a person who is tasked with calculating appropriate invoice payments is provided with a software application program that has equations, business rules, and formulas that together define, track, calculate and report the process, timeline, and deliverables associated with one or more clinical trial studies. In one embodiment, a person will know when invoice payments are due, what payments are due, and which deliverables and activities/budget items would be part of the payments. This important information protects the original estimates of the clinical trial budget, ensures that overpayments are not being made, reports ‘work in process’ and expenditures, and allows for one to anticipate the payments due during a particular time period. Preferred embodiments accept the information, process it through a series of steps, and produce reports that make the invoice analysis and payment verification simple and accurate. Various reports can be produced from information, as described below. In one embodiment, invoices, payments, or work-in-process expenses are organized, analyzed, and verified using algorithms that take into account the complexity of clinical trials and the therapeutic area (e.g., cardiology, neurology). Furthermore, the information can be verified against the actual deliverables provided by the vendors, without the need for phone calls, on-site verification, or other costly and less accurate methods of checking/verification.

Preferred embodiments provides a life science company with reports on the accuracy, or inaccuracy of the vendors' financial accounting and reporting for a clinical trial. Life science companies can be armed with financial metrics that help them make good choices. Equations and business rules work together to define a process, a timeline, and deliverables associated with a clinical trial study.

In one preferred embodiment, one or more clinical trial vendors who have been contracted to provide deliverables to the clinical trial are inputted into a computer system, along with budget items, payment terms and amounts related to the deliverables, and a timeframe in which the budget item is expected to be incurred or paid. The budget items may include monitoring activities, biostatistical activities, and the like, that are being conducted during clinical trials. The prices and costs associated with these activities are included. Invoices can be tracked and managed in dollars, pounds, euros, or any other currency.

In one preferred embodiment, reports are produced that compare and reference budget items and their associated costs. Budget items are standardized from libraries of benchmark information, as described in U.S. patent application Ser. No. 12/121,822 filed on May 16, 2008, now U.S. Published Patent Application No. 2008/0288285 (Mancini et al.), which is incorporated herein by reference. The reports may include a series of financial and operational accounting showing the portion of the budget used, and projecting costs on a time basis, and other reports. Reports may also be provided that show where discrepancies exist within any invoice submitted for payment. A portal that links in live feeds of clinical trial information, such as one described in U.S. Published Patent Application No. 2007/0067189 (Boris et al.), which is incorporated by reference herein, will actually calculate and verify without the need to check deliverables completed with the clinical team or a vendor. (The portal is referred to as a “reportal” in U.S. Published Patent Application No. 2007/0067189. A portal is a site designed to act as an entryway to the World Wide Web.) In fact, this type of report may eliminate the need for any invoice to be sent by a vendor, in order for the appropriate payments to be made to vendors.

FIG. 13 shows an apparatus for calculating appropriate invoice payments associated with a clinical trial study. Broadly stated, the apparatus of FIG. 13 operates as follows:

1. A software application program is provided that has equations and business rules that together define a process, a timeline, and deliverables associated with a clinical trial study. Some of the equations relate to revenue/cost relationships and the timing thereof, and some of the equations relate to cash inflows and outflows and the timing thereof. The clinical trial study has a plurality of phases, and at least some of the business rules relate to the trial study phases. 2. The following items are entered into the program:

a. entities that have been contracted to provide the deliverables to the clinical trial study,

b. budget items and amounts related to the deliverables for the respective entities that have been contracted to provide the deliverables, and

c. for at least some of the budget items, a time frame in which the budget items are expected to be incurred or paid.

These items are obtained from contracts entered into by the entities contracted to provide the deliverables. 3. Appropriate invoice payments for the deliverables for the respective entities that have been contracted to provide the deliverables at a specific time frame are automatically calculated using the equations and business rules in the program, and the items entered into the program.

One useful purpose of knowing what are the appropriate invoice payments during the course of a study is that reserves may be set aside for the payments without any uncertainly as to whether the reserves are too low or too high.

Optionally, invoices received from the entities at a specific time frame may be compared with the appropriate invoice payments to identify any invoices that may not be appropriate.

FIG. 14 shows an apparatus for analyzing invoices for a clinical trial study to identify whether invoices are appropriate or not appropriate at a particular time frame in the study. Broadly stated, the apparatus of FIG. 14 operates as follows:

1. A software application program is provided that has equations and business rules that together define a process, a timeline, and deliverables associated with a clinical trial study. 2. The following items are entered into the program:

a. entities that have been contracted to provide the deliverables to the clinical trial study,

b. budget items and amounts related to the deliverables for the respective entities that have been contracted to provide the deliverables,

c. for at least some of the budget items, a time frame in which the budget items are expected to be incurred or paid, and

d. invoices from the entities that have been contracted to provide the deliverables to the clinical trial study, the invoices including budget items, amounts and a time frame.

3. Patient status data and patient diagnostic data obtained from the entities that have been contracted to provide the deliverables to the clinical trial study are automatically inputted into a comparison engine. 4. The comparison engine automatically identifies invoices that are appropriate and not appropriate at a particular time frame in the study in view of the equations and business rules in the program, the items entered into the program, and the inputted patient status data and patient diagnostic data. Inappropriate invoices, such as those that violate a business rule, preferably cause an “Alert” which would trigger a manual scrutiny of the invoice and additional investigation before the invoice payment is authorized.

When reviewing invoices, the FIG. 14 apparatus provides additional checking capabilities because the invoices are not only being reviewed to determine if they are potentially appropriate in view of the expected deliverables at certain time frames, but actual patient status and diagnostic data provides additional checking capabilities. For example, an invoice might be appropriate at a particular time frame, but the patient status and diagnostic data reveals that the deliverables likely did not occur, and thus the invoice should not be paid.

FIG. 15 discloses an apparatus for automatically generating an accounting for a clinical trial study, wherein the clinical trial study has a total budget amount and a total amount of deliverables. Broadly stated, the apparatus of FIG. 15 operates as follows:

1. A software application program is provided that has equations and business rules that together define a process, a timeline, and deliverables associated with a clinical trial study. 2. The following items are entered into the program:

a. entities that have been contracted to provide the deliverables to the clinical trial study,

b. budget items and amounts related to the deliverables for the respective entities that have been contracted to provide the deliverables,

c. for at least some of the budget items, a time frame in which the budget items are expected to be incurred or paid.

3. Patient status data and patient diagnostic data obtained from the entities that have been contracted to provide the deliverables to the clinical trial study are automatically inputted into a processor. 4. The processor automatically generates an accounting of the clinical trial study using the equations and business rules in the program, the items entered into the program, and the inputted patient status data and patient diagnostic data. The accounting is based on a percentage of the deliverables completed and also provides a percentage of the deliverables that are completed. The accounting provides expenses to record for accounting purposes under generally acceptable accounting principles.

FIG. 16 discloses an apparatus for automatically generating a projection of cash flow needs for a clinical trial study, wherein the clinical trial study has a total budget amount and a total amount of deliverables. Broadly stated, the apparatus of FIG. 16 operates as follows:

1. A software application program is provided that has equations and business rules that together define a process, a timeline, and deliverables associated with a clinical trial study. 2. The following items are entered into the program:

a. entities that have been contracted to provide the deliverables to the clinical trial study,

b. budget items and amounts related to the deliverables for the respective entities that have been contracted to provide the deliverables,

c. for at least some of the budget items, a time frame in which the budget items are expected to be incurred or paid.

4. A projection of cash flow needs of the clinical trial study is automatically generated using the equations and business rules in the program, and the items entered into the program.

Information such as appropriate and inappropriate invoice payments, an accounting for the clinical trial study, and cash flow needs for the clinical trial study can broadly be characterized as business intelligence information. Upon loading the software application program with the items discussed above, the clinical trial study is effectively “modeled.” From the model, the various types of business intelligence information can be extracted as needed.

The entities referred to herein include service providers, vendors, subcontractors, and suppliers. The “time frame” referred to herein includes a specific date, or a time window. “Diagnostic data” includes items such as lab data and EKGs/ECGs.

Any conventional database or spreadsheet program may be used in the software application program shown in FIGS. 13-16. Likewise, the processor and comparison engine shown in FIGS. 13-16 may be part of one or multiple general-purpose computers, such as personal computers (PC) that run a Microsoft Windows® or UNIX® operating system. Furthermore, although the disclosed embodiments manage data using spreadsheets, the scope of the present invention includes embodiments that use other forms of software that can perform the equivalent function of managing data via spreadsheets.

II. Detailed Disclosure

The present invention is described in the context of a commercial service offered by Numoda Corporation, Philadelphia, Pa. In the disclosed embodiments, Numoda is a general contractor for a clinical trial study, and thus acts as both a managing entity and a contracted entity (service provider) for the study. However, the scope of the present invention is not limited to this particular implementation of the invention. For example, a pharmaceutical company could directly host and manage the software programs for its own studies.

FIGS. 1A-1F show a blank Contracted-Budget Summary. This summary represents the totals across all entities and includes change orders obtained from contracts entered into by the entities contracted to provide the deliverables. Change orders are the updates of costs and budget items that might occur within a project. These change orders can occur at any time and are related to additions or subtractions in the scope of project deliverables and assumptions. Column B shows the list of products and services that are budget items related to the deliverables for a particular clinical trial. There are no limits to the number of clinical trials that can be managed by the system. The system can also be used with clinical programs, which consist of multiple clinical trials combined in a grouping. FIG. 1A, column B, rows 3, 8, 17 and FIG. 1B, column B, row 30 show the classification of types of budget items. Column B uses standard classifications and budget items, similar to the standard classifications discussed in U.S. Published Patent Application No. 2008/028825. The use of standards is not necessary, but may increase the value of the process when used across many trials and clinical programs. There are many products and services provided for clinical trials that are actually standard across the industry, and there is a benefit to using standard terminology.

FIG. 1A, column C shows the corresponding column with the contracted amounts for each of the budget items in each row that are the total across all of the rest of the columns. Column C, rows 15 and row 25 show the subtotal for the budget items in the rows above, in the same column, and row 27 shows a total.

FIG. 1B, column C, rows 45 and 48 show contracted amounts for other budget items and for the total project, respectively. FIGS. 1A and 1B show subtotals of groupings of budget items that are well understood in the industry. These subtotals are on rows 15 and 25 on FIG. 1A and row 45 on FIG. 1B. The grand total is on row 48 of FIG. 1B. FIG. 1C, row 1 is the product and services activities, and row 2, columns E, G, I and K and M show the several different suppliers/entities that will be providing products and services for the clinical trial. FIG. 1C, rows 3-26 shows the place where the costs are entered for the budget items. There is no limit to the number or type of suppliers that can be entered. The lists of groups continue from FIG. 1E, row 1, column O. FIG. 1F, column Q rows 27-48 shows the place where costs are displayed for the budget items. FIG. 1E, column Q, rows 1 and 2 shows the General Contractor value. FIG. 1E, column Q, rows 3-26 shows the total of all entities for budget items. FIG. 1F, column Q, rows 27-48 shows more totals.

Groups are part of the business rules contained in the process. These business rules protect the clinical trial budget by including all necessary groups of products and services that will be required for a successful trial. There is no limitation to the groups, and it is possible to include varying business rules that relate to different types of studies that require different types of services. For example, other diagnostics products and services group can be added. FIG. 1C, row 2, and FIG. 1E, row 2 represent the names of the suppliers/entities that are responsible for the group of products and services. All other rows on FIGS. 1C, 1D, and 1E in column E, G, I, K, M, and O represent costs for individual budget items related to products and services provided by each contract entity. On FIG. 1E, column Q shows the total value.

FIGS. 2A-2F show the summary of the budget in a “formula” view that reveals some of the underlying equations and business rules. These figures also show the link to the formulas related to formulas and equations for change orders associated with the project. There are many business rules related to the timing of the products and services used for a clinical trial project. For example, each clinical trial protocol will detail the clinical rules for the study. Business rules are extrapolated from these protocols. There are rules about the timeline for a study (e.g., how long screening of patients is estimated, treatment time period, closeout). There are rules about the costs associated with a clinical study site performing study protocol procedures for patients. There is no limitation to the amount of rules or the types of rules that can be used.

FIG. 2A, column B shows the budget items, and column C shows the formulas for the cost of the work of managing all of the entities and their payables. Also shown here are the formulas for the integrations, the portal and the ongoing consolidation and reconciliation and entity management that allow for the work shown in rows 3-7, 9-14, and 18-24. FIG. 2B, column C shows the formulas for the cost of the work of managing all of the entities and their payables shown in rows 30-48. FIG. 2C, columns E, G, I, K and M, row 1 shows the groups of activities, and row 2 shows the name of the entities. In the same columns, row 15 and 25 shows the formulas and all other rows show the link to the change order formulas. FIG. 2D, column E, G, I, K and M, rows 27, 45 and 48 show the formulas and all other rows show the links to the change order rules, equations and formulas. There is no limit to the number or type of formulas that can be used. The format shown here can be maintained in any database format. FIG. 2E. column O represents another entity, and column Q shows the formulas for the totals across all columns on FIG. 2A-2E and includes any costs related to change orders. FIG. 2F shows the additional rows for column O and the formulas for the additional rows in column Q, and the link to the formulas, business rules and equations for the change orders. FIG. 2 in its entirety, shows the actual budget at any given point in time, including any or all change orders.

FIGS. 3A-3F show an actual budget summary for an actual clinical trial project that includes the budget items and costs, after all contract information has been entered. Change orders have not been included in these figures. These figures also show a set of contracts from the entities that will be detailed for an actual study. Three entities will be further discussed in this example. One of the entities included in these figures is a diagnostics provider for the trial (in this case, a vendor that provides laboratory analysis). Another entity is a clinical services provider (in this case, a Contract Research Organization, often referred to as a CRO.) FIG. 3A, column B, rows 3-26 and FIG. 3B, column B, rows 27-48 show budget items for Entity #1. Column C in FIGS. 3A and 3B shows the corresponding costs for Entity #1, in the same rows.

FIG. 3C, columns E, G, I, K and M, rows 3-26, FIG. 3D, column E, G, I, K and M, rows 27-48 shows the costs for each of the entities. FIG. 3C, column I, rows 3-26, and FIG. 3D, column I, rows 27-48 represent the costs for the CRO (Entity #4) that will be highlighted later. FIG. 3C, column M, rows 3-26, and FIG. 3D, column M, rows 27-48 represent the costs for the lab provider (Entity #6) that will be highlighted later.

FIG. 3E, column O, rows 3-26, and FIG. 3F, column O, rows 27-48 show the costs for another entity. FIG. 3E, column Q, rows 3-26 and FIG. 3F, column Q, rows 27-48 show the total costs for all entities for each budget item for the original contract, excluding any change order budget items and costs.

FIGS. 3G-3J, column A, all rows, show the detail of the individual specifications and assumptions that were used to decide the necessary budget items for the job, and column B shows the corresponding units. The assumptions in column A come directly from the contract with the sponsor, which contains the entire budget items, units, and costs for all the entities. This is used to determine the business rules for this project.

FIGS. 3H-3J, column A show more detail, and FIGS. 3H-3J, column B show more units. For each contract, the budget items, assumptions, and units identifies items that are then entered.

FIG. 3K is the payment schedule, which will set the rule for the timing of invoices and appropriate payments. This information sets the time frame in which the budget item is expected to be incurred or paid. Also included are the budget items, specifications, units, and costs related to the deliverables for the respective entities who have been contracted to provide the deliverables, and for at least some of the budget items. Also included for each contract, is any other relevant information.

FIG. 3L shows the specifications for Entity #4 (the CRO) and FIGS. 3M-3P show the budget and units for entity # 4 (the CRO), which will establish the rules for the payments to this entity and which will be entered and seen in the budget summary shown in FIGS. 3C and 3D, column I. FIG. 3Q shows the specifications for Entity #6 (the Lab) and shows the unit price for Entity #6 (the Lab), which will establish the rules for the payments to this entity. The total budget will be calculated based on the rules. The summary for this entity is seen in FIGS. 3C and 3D, column M. FIG. 3R shows more specific details of the budget item for the investigator fees/grants as seen in FIG. 3N from the Entity #4 contract. This budget item “Investigator Fees” is reflected in the budget summary shown in FIG. 3D, column I, row 35. This budget item is a significant item in a budget because these funds are used to pay doctors who will enroll patients into the study. Timely and appropriate payments for the investigators can often mean improved results in the enrollment of the trial. Likewise, the ability to see the costs and the payments made to investigators will provide ‘intelligence’ on whether the doctors are enrolling the right patients, based on the rules.

FIG. 3S shows an example change order for the project that has occurred for this example because medical monitoring was added as a new service to be performed by Entity #4. FIG. 3T, column I, row 13 shows the change in the budget cost for the Entity #4 with the addition of the new services. FIG. 3U, column Q, row 13 shows the change in the total budget for the item. FIG. 3V, column Q, row 48 shows the change in the total budget overall.

The following figures explain how each budget item is processed so that it can be entered into the Project Budget (e.g., units conversion, time frame conversion).

FIGS. 4A-4H show where each budget item, cost, and the specific rules are entered so that it can be seen in the Project Budget Summary.

FIG. 4A, column B, row 3 shows the name of Entity #4, the CRO. Rows 4-13 are the detailed budget items that represent work that will be completed by the entity during study set up. These items come from budget items discussed in U.S. Published Application No. 2008/0288285.

FIG. 4A, column C, row 5 shows the number of investigators for the project that was taken from FIG. 3L, column B, row 4 specifications showing the number of sites. This is an example of the business rules. The business rule is that each site represents a single investigator selection. Therefore, the units are filled in with the number “12.” Some of the budget items, unit costs in FIG. 4A, column D, and the original contract cost in column E will be pre-populated in the case where the business analysis process disclosed in U.S. Published Application No. 2008/0288285 (also, referred to below as “the business analysis tool”) is used. In these cases, the entity can save tremendous time in proposal writing and is simply given the number of units and the budget in which to work.

In some cases, the budget items, units and costs are calculated based on the timeline. For example, in FIG. 4A, column C, row 24, the budget item “Interim Monitoring Visits” number of units is calculated based on the enrollment and treatment period according to the frequency detailed in the specifications and assumptions. The unit price in FIG. 4A, column D is provided from the business analysis tool. Any budget items, units or unit prices that do not explicitly appear in the contracts from the contracting entities, but which are known to be part of the clinical trial study, are entered in columns A-C of FIGS. 4A-4D so that all costs are accounted for. In some instances, the budget item and unit price already exists, and only the units need to be added. FIG. 4B, column B, row 59 is an example of a budget item entered for Entity #6. FIG. 4B, column C, row 61 shows an example of a combination of how to calculate the total of the patients according to the business rules for the protocol for the clinical trial. In this example, when the assumptions for number of months and the frequency for monitoring visits are provided by the business analysis tool, the process described herein will calculate the number of units, so that it is not necessary to enter the units. Number of units are automatically pre-populated. FIGS. 4C and 4D, column B shows more budget items and columns C and D show the units and unit costs.

FIG. 4C, column B, row 122 shows the investigator meeting budget item and FIG. 4D, column B, row 124 shows the investigator payments (grants). Across the same rows in columns C and D are the units and the unit costs. FIG. 4D, column B, rows 137-142 show the budget items for Entity #6. Columns C and D in the same row show the units and the unit costs. FIGS. 4A-4D, column E, show the original contracted total for each of the budget items. The total of the costs of the budget items for each entity is seen on FIG. 4D, rows 160-164.

FIGS. 4A-4D, columns G, H and I show the place for entry and calculation of the units, unit price, and total for change order #1 (CO#1). In the same figures, columns K, L, and M show the place of entry and calculation for change order #2 (CO#2). There is no limit to the number of change orders or the addition of budget items. FIGS. 4E-4H, column AY shows the total number of units that are calculated for each of the budget items for all of the change orders and the original contract. In the same figures, column AZ shows how to calculate the total of the original contract and the change orders costs for each budget item together. FIGS. 4E-4H, column AZ is linked to the budget summary shown in FIGS. 3A-3F, columns C, E, G, I, K, M and O, lines 3-14, 17-24 and 30-34. It is very important to track and calculate the additional costs of the change orders, as well as to track the changes in units and unit costs of each budget item for each of the entities. Most clinical trials have changes during the trial, and change orders are often difficult to track manually. Conventional industry practice is to simply record that a change order exists and that it has affected the total budget, rather than track and verify that each unit was provided and is appropriate to pay.

FIG. 5A shows how business rules are set for the investigator according to contracts with each of the investigators, an example of which is seen in FIG. 3R. FIG. 5A, column B is the visit schedule according to the business rules set by the protocol of the trial. Column C shows the costs per visit according to the contract with one investigator.

FIG. 6A, column A shows the patient number that will come into this data entry location from the portal. FIG. 6A, column B shows the patient initials. FIG. 6A, column C contains the business rules for the calculation. For example the R in column C, row 5 means that the patient was randomized and so all of the visits are allowed to be paid. In column C, row 6 the D means that the patient was discontinued, and FIG. 6A, column E, row 6 shows the discontinued date. The rule will calculate only the visits during the certain time period until the discontinued date will be appropriate to pay. FIG. 6A, column F shows the drug dispensed Y=yes. If in column F there is a letter N (N=NO) and in column C there is a letter AS (AS=Active screened), this signifies that no further visits costs are to be expected or should be paid for this patient. FIG. 6A, column G, row 4 shows an example of a type of visit following the business rules of the protocol. Column G, row 6 shows the date that visit type occurred.

FIG. 6B, column N, rows 2 and 3 show the status of the completion of certain forms filled out by the investigator. This information is used if the contract with the investigator is based on status of a certain number of forms. Column N, row 4 shows the completed status. Column O, row 4 shows the locked status. These statuses are also used as the business rule to track the status of the work of the clinical monitors in the study and will calculate the appropriate payment for the monitor for the study. The information in these columns and the adjacent columns P and Q comes from the portal.

FIG. 6C, column S, row 5 shows the results of the formula for the date rules for when the investigators are allowed to begin their work. FIG. 6C, column T, row 5 shows the date that will drive how many visits should be paid or rejected as inappropriate at that point in time. This date can be entered as a future date, once the schedule of visits is made so that the cash flow needs will be calculated and reported. Investigator payments will not be allowed to be made outside these date rules. FIG. 6C, column U, row 5 shows either a 0 or a 1 based on the timeline rules set on column S and T. This calculates the right amount to be paid to each investigator at any point in time for any patients, or in total, because FIG. 6A, column A shows the rules for which patient is associated with each investigator. For example, in FIG. 6A, column A, row 5 shows a patient number 10001 with the first two digits signifying the investigator, here, investigator “10.” FIG. 6E, column AU, row 5 shows the total of visits for that patient. Other patients in FIG. 6A match respective patients in FIG. 6E having the same row. This is matched against the portal and will allow for cross checking.

FIG. 6D, column U, row 122 is the total for a particular visit type for all patients and all doctors, which is crosschecked against the portal totals and will show an error if not matching.

Now that the rules are in place for the payments to investigators according to the patients that the investigators will treat during the trial, return back to FIG. 5A, column D. This reflects the total of the actual cost and percentage of the work completed at a particular time point, based on the business rules. FIG. 5A, column C, row 8 shows the entry point for any advance payment. Sometimes, the investigator contracts require payment in advance, in which case the system will calculate and subtract from the total to be paid when all the patients are enrolled by the investigator. FIG. 5A, column D, row 13 shows the total projected costs based on the protocol business rules and the contract business rules for this type of visit (visit 1). Row 36 shows the total for the patients with the status ‘completed’. In the case where there is a special rule in an investigator contract to pay the investigator for a screen failure patient, row 39 columns C and D will calculate the total to be paid.

FIG. 5A, column H, row 4 will show the actual total number of visit 01 types of visits from the portal. This row shows the link to the business rules, which are directly linked to the portal. Column H, row 13 shows the total cost for visit 01 types based on the individual contracts with the investigators. Row 39 shows any additional cost to be paid per special contract arrangements and row 41 shows the total for that column.

FIG. 5D, column AV row 41 shows the total costs for all visit types and other costs for work for patients that have completed the study. This example is shown for investigators who are paid under the business rule that they are to be paid by completed patients. Row 43 shows the advance payment that is subtracted for accuracy of total payments to investigators. Row 45 shows the total with the advance payment subtracted. This same type of function is used to track and calculate payments for monitoring visits. These formulas and costs are used for reconciliation purposes against the total budget. For example, the advance payment to the investigators is only reconciled at the end of the study.

FIGS. 3A-F show the completed Project Budget after all contracts have been entered. Tracking the actual invoice and costs for the Entity #4 are explained by the following figures.

FIGS. 7A and 7B is an actual invoice from Entity #4 who has been contracted to provide the deliverables to the clinical trial study. The invoice includes budget items, amounts and a time frame. FIG. 7A is the cover page that comes with an invoice that shows the total cost amount for this invoice. In this example, the relevant information that appears on the invoices which get entered into the Project Budget is the cost for a specific budget item. (Budget items are also discussed in U.S. Publication No. 2008/0288285) The cost is $42,294.13. Often, this information is all the information that is sent to the sponsor, because the agreement with the entity could be based on milestones, invoicing as work is completed, or in another format. FIG. 7B reflects the invoice tracking format to make it easy when the cost is calculated, to see the budget item that was performed, and to see how the cost of this budget item is calculated against the total budget for Entity #4. FIG. 7E, column H, row 47 shows the total amount of this particular invoice, and FIGS. 7D and 7E, column H, rows 2-46 show the subtotal amounts for this particular invoice. This invoice reflects work completed several months ago that is only invoiced now. The invoice and the attached information in these figures provides data to manage accounts payable and current cash flow. However, it does not reflect the actual work done at this point in time, and will not give information about what bills to expect at a later point in time.

FIGS. 8A-8P show where each invoice item is entered into the Project Budget and also show how each invoice item is processed so that it can be entered into the Project Budget (e.g., units conversion, time frame conversion). These figures also include a snapshot of the budget after entry of the invoice.

Each detailed budget item is shown in column A of FIGS. 8A-8D. FIG. 8A, column A, rows 10-57 are the budget items in detail for Entity #4. FIG. 8B, column A, rows 73-103 shows each detailed budget item for Entity #6. FIGS. 8C and 8D, column A shows the detailed budget items for other entities. FIGS. 8A, 8B, 8C, and 8D, column B shows the number of units for each of the detailed budget items. FIGS. 8E, 8F, 8G, 8H, column C shows the unit price for each of the budget items. In the same figures, column D shows the cost associated with each of the budget items and a total for each section that relates to a portion of work that is to be done during a particular time period during the project. For example, in FIG. 8A, row 11-20 are items that are provided during the study set up and regulatory portion of the project, a portion of which occurs within the first few months of the project according to the business rules shown in figures discussed below.

FIGS. 8E-8P are used to verify the appropriate of an invoice and to accept information from a portal that will confirm that budget items were delivered.

FIGS. 8E-8H shows where the spreadsheet will accept either the unit number on the invoice (column F), or the percent completed (column G), or the total (column H). If the spreadsheet receives the unit number or the percent completed, then it will calculate the other values. This process allows for the freedom to accept information in various formats and to utilize whatever information is most readily available.

FIGS. 8E-8H columns F, G, and H represent the total cost invoiced within a particular time period. The spreadsheet will accept the information from the invoice and will calculate the sum of the invoice for all the periods that are paid. FIGS. 8I-8L, columns J, K and L reflect the units, unit price, and total for the time period of month 01.” FIG. 8I-8L, columns N, O and P reflect the units, unit price, and total for the time period of “month 02.” FIG. 8M, column BR reflects the automatic reconciliation of the costs, unit, and total for each of the budget items. For example, the budget item for ‘Kickoff Meeting’ as seen in FIG. 8A, row 15, column B is zero because the number of units allowed for this budget item is zero. Thus, the spreadsheet displays that the cost is ‘over’ the budget. By doing this automatically, an alert is generated that there is a discrepancy in the invoice. Such discrepancies may also be used when the invoice amount exceeds budget items that are non-zero amounts (e.g., 12 units). If the invoiced amount of work exceeds the budget amount, the portal may be further examined to check and see exactly what work is showing as being actually completed. In some cases, calls should be made to other individuals or other departments about the completion of the work for this budget item. This process is vastly simplified by using the present system because an individual can work on the exceptions rather than call every individual to check every single budget item. The system compares invoices received from the entities at a specific time frame with the appropriate invoice payments and identifies any invoices that are not appropriate and that are appropriate, as calculated by the equations and business rules, as seen in FIG. 8M, column BR. This example has taken a representative sample invoice item, here, ‘kick off meeting’ and shows the equations and/or business rules that the invoice items are tested against.

FIGS. 18A-18AN show all of the formulas and business rules for one sample clinical trial study. These sets of figures reflect the work related to the entities, budget items, costs, timeframe, and change orders for the study.

The process described herein provides for an accurate, timely, “work in process” accounting. One reason that it is so difficult to account for the work in process and the related ‘booked expenses’ is because an invoice is often sent by a supplier or contracted entity many months after the expense has been incurred by the sponsor of the clinical development. The sponsor of clinical development is responsible to provide an accounting of all money spent within a certain time frame and to account for the actual expenses incurred during a specific time frame. This type of accounting has become very important since the recent accounting scandals and the new rules established under The Sarbanes-Oxley Act of 2002.

FIGS. 10A-10F show how the values in “work-in-process reports” are calculated using the equations and formulas and the business rules of a “work-in-process report” for specific time frames. These figures show every month, as well as the cumulative values. A specific supplier and a specific budget item will be explained. For example, FIGS. 10A-10F show the budget summary for this project, similar to what has been shown in other figures. However, in this part of the process, FIGS. 10A and 10B, column K displays the original budget cost with the additional cost of the change order calculated together. FIG. 10B, row 50 displays the total project budget that has been calculated and now includes all of the change orders. In this example, only one change order is included to make the example easy to visualize and to understand. There are usually many change orders, making it complicated and nearly impossible to manage using conventional tools.

FIG. 10A, column B, row 14 shows a budget item that contains several detailed budget items for Biostatistics and Medical Writing Activities that will be provided by entity #4, who has been contracted to provide the deliverables to the clinical trial study. The amounts related to the deliverables for the respective entity that has been contracted to provide the deliverables is seen in FIG. 10A in column K, row 14.

The appropriate invoice payments for the deliverables for the respective entities that have been contracted to provide the deliverables will also be automatically calculated for a specific time frame. The time frames in which the budget item is expected to be incurred or paid is shown on FIGS. 9C, 9E, 9G, 91, 9K and 9M. The timeframe for the budget item can be seen in these figures as well. For example, FIG. 9C, column AP, row 2 shows that this column and the associated amount in column AQ relate to the timeframe for month 01. In the same figure, column AW relates to the timeframe for month 02. This is done using the business rules seen in FIGS. 9C-9N, which display the business rules for the completion of work expected within a particular time frame. FIG. 9C, columns AP and AQ, row 2 identify the projected work percentage to be completed for month 01 for the respective columns. FIG. 9C, column AP, row 4 reflects the business rule for the percentage of work expected to be completed for the integrations budget item (that can be seen in FIG. 9A column B row 4). FIGS. 9C and 9D column AQ in each row provides an accounting of expenses to record for accounting purposes under generally acceptable accounting principles related to each budget item and the percentage completion. FIG. 9D, row 50, column AQ provides the total of expenses. This information reflects how expenses should be booked for accounting purposes, which is very different from simply recording the only invoice that has been obtained from supplier, during this time period shown in FIGS. 9C-9N.

The underlying equations relate to revenue/cost relationships and the timing thereof, as well as cash inflows and outflows and the timing thereof. The accounting is based on a percentage of the deliverables completed and the invention provides a percentage of the deliverables that are completed. FIG. 9C, column BA shows an accounting of the percentage of work completed that totals the percentage during each specific time frame to the current date. This is an automatically generated accounting of the clinical trial study using the equations and business rules in the program for all of the tracked items and for items related to the live feed of patient status data and patient diagnostic data.

FIG. 11 is a flow diagram that depicts how patient status data and patient diagnostic data is automatically inputted from the entities that have been contracted to provide the deliverables to the clinical trial study. The inputted patient status data and patient diagnostic data are used with one or more of the business rules as part of the automatic verification of invoices and to manage the work in process expenses.

FIGS. 12A-12B show a portion of the portal database that contains patient status data and patient diagnostic data that are automatically checked as part of the business rules described above. This data is available in the portal as the result of a Screening/Enrollment process described in U.S. Published Application No. 2007/0067189, which makes this data readily available to be electronically fed into the system of the present invention, without the need for a person to data enter information. This is a huge advancement over conventional software approaches which typically require data entry and manual checking.

The process described above has many automated components. However, some of the steps in the process may occur manually. For example, some invoices will be manually reviewed against the vendor's contract to convert items into the appropriate units for entry into the software program. In other instances, the software program is programmed to accept the units as they appear on the invoice and convert them automatically into the units that the program needs to perform its calculations. The invoice processing procedures may range from partially automated to fully automated (with OCR capability).

Since the software application program has full knowledge of the status of the clinical trial study at any point in time from both an accounting standpoint and an expected invoice standpoint, the embodiments disclosed in FIGS. 13 and 15 can be combined to provide an apparatus for making automated payments to the contracted entities without even needing to receive or process invoices from the contracted entities.

FIG. 17 shows such an embodiment. A payment engine is programmed to periodically make payments to the contracted entities, whether or not the contracted entities have submitted invoices. Incoming invoices may be either kept solely for reconciliation, if necessary, and thus not processed at all in most instances, or may be inputted and checked for potentially inappropriate charges. Alternatively, the allowed invoice amounts may be offset against the previously made or already authorized payments. The embodiment in FIG. 17 allows for a significant reduction in administrative overhead, particularly if the invoices are not processed and maintained only for reconciliation purposes. In an ideal scheme, contracted entities would be instructed to not even send in invoices. The disclosure provided in FIGS. 1-12 includes all of the necessary components to implement the automated payment feature shown in FIG. 17.

The present invention may be implemented with any combination of hardware and software. If implemented as a computer-implemented apparatus, the present invention is implemented using means for performing all of the steps and functions described above.

The present invention can be included in an article of manufacture (e.g., one or more computer program products) having, for instance, computer useable media. The media is encoded with, for instance, computer readable program code means for providing and facilitating the mechanisms of the present invention. The article of manufacture can be included as part of a computer system or sold separately.

It will be appreciated by those skilled in the art that changes could be made to the embodiments described above without departing from the broad inventive concept thereof. It is understood, therefore, that this invention is not limited to the particular embodiments disclosed, but it is intended to cover modifications within the spirit and scope of the present invention. 

1. An automated method of calculating appropriate invoice payments associated with a clinical trial study, the method comprising: (a) providing a software application program having equations and business rules that together define (i) a process associated with the clinical trial study, (ii) a timeline associated with the clinical trial study, and (iii) deliverables associated with the clinical trial study; (b) entering into the program: (i) entities that have been contracted to provide the deliverables to the clinical trial study, (ii) budget items and amounts related to the deliverables for the respective entities that have been contracted to provide the deliverables, (iii) for a plurality of the budget items, a time frame in which the budget items are expected to be incurred or paid; and (c) automatically calculating using a processor appropriate invoice payments for the deliverables for the respective entities that have been contracted to provide the deliverables at a specific time frame using in the calculation of the appropriate invoice payments: (i) the equations and business rules in the program, and (ii) the items entered into the program in step (b)(i)-(iii), wherein the calculation of appropriate invoice payments is performed without entering into the program or otherwise using invoices from any of the entities.
 2. The method of claim 1 further comprising: (d) comparing invoices using a comparison engine received from the entities at a specific time frame with the appropriate invoice payments and identifying any invoices that may not be appropriate.
 3. The method of claim 1 wherein items (b)(i)-(iii) are obtained from contracts entered into by the entities contracted to provide the deliverables.
 4. The method of claim 1 wherein a plurality of the equations relate to revenue/cost relationships and the timing thereof.
 5. The method of claim 1 wherein a plurality of the equations relate to cash inflows and outflows and the timing thereof.
 6. The method of claim 1 wherein the budget items and amounts include units of the deliverables.
 7. The method of claim 1 wherein the clinical trial study has a plurality of phases, and a plurality of the business rules relate to the trial study phases.
 8. A method of automatically generating an accounting for a clinical trial study, the clinical trial study having a total budget amount and a total amount of deliverables, the method comprising: (a) providing a software application program having equations and business rules that together define (i) a process associated with the clinical trial study, (ii) a timeline associated with the clinical trial study, and (iii) deliverables associated with the clinical trial study; (b) entering into the program: (i) entities that have been contracted to provide the deliverables to the clinical trial study, (ii) budget items and amounts related to the deliverables for the respective entities that have been contracted to provide the deliverables, and (iii) for a plurality of the budget items, a time frame in which the budget items are expected to be incurred or paid; (c) automatically inputting patient status data and patient diagnostic data obtained from the entities that have been contracted to provide the deliverables to the clinical trial study into a processor; and (d) automatically generating using the processor an accounting of the clinical trial study using in the automatic generation of the accounting: (i) the equations and business rules in the program, (ii) the items entered into the program in step (b)(i)-(iii), and (iii) the inputted patient status data and patient diagnostic data in step (c), wherein the accounting is generated without entering into the program or otherwise using invoices from any of the entities.
 9. The method of claim 8 wherein the accounting is based on a percentage of the deliverables completed.
 10. The method of claim 8 wherein the accounting provides a percentage of the deliverables that are completed.
 11. The method of claim 8 wherein the accounting provides expenses to record for accounting purposes under generally accepted accounting principles.
 12. A method of automatically generating a projection of cash flow needs for a clinical trial study, the clinical trial study having a total budget amount and a total amount of deliverables, the method comprising: (a) providing a software application program having equations and business rules that together define (i) a process associated with the clinical trial study, (ii) a timeline associated with the clinical trial study, and (iii) deliverables associated with the clinical trial study; (b) entering into the program: (i) entities that have been contracted to provide the deliverables to the clinical trial study, (ii) budget items and amounts related to the deliverables for the respective entities that have been contracted to provide the deliverables, (iii) a plurality of the budget items, a time frame in which the budget item is expected to be incurred or paid; and (c) automatically generating using a processor the projection of cash flow needs of the clinical trial study using in the automatic generation of the projection of cash flow needs: (i) the equations and business rules in the program, and (ii) the items entered into the program in step (b)(i)-(iii), wherein the projection of cash flow needs is performed without entering into the program or otherwise using invoices from any of the entities. 